create external table jms_dm.dm_repair_access_sum_dt 
(
scan_network_code        string COMMENT '维修点编码' ,
scan_network_name        string COMMENT '维修点名称' ,
 total_in_num             bigint COMMENT '入库数量' ,
 damage_num  bigint COMMENT '未仲裁上报数量' ,
 total_out_num   bigint COMMENT '出库数量' ,
 center_num   bigint COMMENT '中心入库数量' ,
 total_off_num    bigint COMMENT '报废数量' ,
date_time timestamp COMMENT '' )
comment 'insert overwrite table jms_dm.dm_repair_access_sum_dt partition (dt)'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_repair_access_sum_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
